create or replace view vac_lov_entries_4_1 as
with lov_e as
(
select
 workspace,
 workspace_display_name,
 application_id,
 application_name,
 list_of_values_name,
 display_sequence,
 display_value,
 return_value,
 lov_entry_template,
 condition_type,
 condition_type_code,
 condition_expression1,
 condition_expression2,
 build_option,
 primary_application_id,
 translated_app_language,
 last_updated_by,
 last_updated_on,
 component_comment,
 lov_id,
 lov_entry_id,
 component_signature
 from APEX_APPLICATION_LOV_ENTRIES
)
select
 workspace,
 workspace_display_name,
 application_id,
 application_name,
 list_of_values_name,
 display_sequence,
 last_updated_by,
 last_updated_on,
 lov_id,
 lov_entry_id,
 primary_application_id,
 'APEX_APPLICATION_LOV_ENTRIES' src_view_name,
 u_name,
 u_value
 from lov_e
  UNPIVOT INCLUDE NULLS (
   u_value
   FOR    u_name
   IN
   (
       display_value,
       return_value,
       lov_entry_template,
       condition_type,
       condition_type_code,
       condition_expression1,
       condition_expression2,
       build_option,
       translated_app_language
   )
  );

